<?php
session_start();

include("DBConnection.php");

?>

<html>
<head>
	<link rel="stylesheet" href="format.css" type="text/css">
	<link rel="stylesheet" type="text/css" href="format.css" >
</head>
<body  bgcolor="white" text="black" topmargin="0" marginheight="0"  leftmargin="0" marginwidth="0" style="margin:0px;padding:0px;height:100%">

<BR>

<TABLE border=0>
<TR><TD> <Font class=head><u>Winter</u></Font> </TD> <TR>
<TR><TD>
	<?php
	//alle Winter Spielorte ermitteln
	$sql = "Select * From F_Spielort Where Jahreszeit=0";
	$result = mysql_query($sql) or die("Abfrage Fehler: ".$sql);	

	while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
	echo "<TABLE class=tab border=1>";
	echo "<TR>";
	echo "  <TD valign=top>Treffpunkt</TD>";
	echo "  <TD class=tab width=300px>".$row['Ort']."</TD>";
	echo "</TR>";
	echo "<TR>";
	echo "  <TD valign=top>Der Platz</TD>";
	echo "  <TD class=tab><a href='platz.php?p=".$row['ID']."' target=_blank border=0><img src='Fotos/platz_".$row['ID'].".jpg' alt='weitere Bilder' width=150px border=0></A> </TD>";
	echo "</TR>";
	echo "<TR>";
	echo "  <TD valign=top>Anfahrt</TD>";
	echo "  <TD class=tab><a href='skizze.php?p=".$row['ID']."' target=_blank><img src='Fotos/skizze_".$row['ID'].".jpg' alt='Lageplan' border=0 width=150px></a></TD>";
	echo "</TR>";
	echo "<TR>";
	echo "  <TD valign=top>Merkmale</TD>";
	echo "  <TD class=tab>";
	echo $row['Merkmale'];
	echo "  </TD>";
	echo "</TR>";
	echo "</table><BR>";
	}
	?>
    </TD>
</TR>
<TR><TD>&nbsp;</TD></TR>
<TR><TD> <Font class=head><u>Sommer</u><BR><BR></Font> 

	<?php
	//alle SommerSpielorte ermitteln
	$sql = "Select * From F_Spielort Where Jahreszeit=1";
	$result = mysql_query($sql) or die("Abfrage Fehler: ".$sql);	

	while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
	echo "<TABLE class=tab border=1>";
	echo "<TR>";
	echo "  <TD valign=top>Treffpunkt</TD>";
	echo "  <TD class=tab width=300px>".$row['Ort']."</TD>";
	echo "</TR>";
	echo "<TR>";
	echo "  <TD valign=top>Der Platz</TD>";
	echo "  <TD class=tab><a href='platz.php?p=".$row['ID']."' target=_blank border=0><img src='Fotos/platz_".$row['ID'].".jpg' alt='weitere Bilder' width=150px border=0></A> </TD>";
	echo "</TR>";
	echo "<TR>";
	echo "  <TD valign=top>Anfahrt</TD>";
	echo "  <TD class=tab><a href='skizze.php?p=".$row['ID']."' target=_blank><img src='Fotos/skizze_".$row['ID'].".jpg' alt='Lageplan' border=0 width=150px></a></TD>";
	echo "</TR>";
	echo "<TR>";
	echo "  <TD valign=top>Merkmale</TD>";
	echo "  <TD class=tab>";
	echo $row['Merkmale'];
	echo "  </TD>";
	echo "</TR>";
	echo "</table><BR>";
	}
	?>   

    </TD>
<TR>
</TABLE>

</body>
</html>
